package com.ruoyi.system.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.JingfeiZhuanjiaMonth;
import org.apache.ibatis.annotations.Param;

/**
 * jingfeizhuanjiayueMapper接口
 * 
 * @author ruoyi
 * @date 2024-07-11
 */
public interface JingfeiZhuanjiaMonthMapper 
{
    /**
     * 查询jingfeizhuanjiayue
     * 
     * @param id jingfeizhuanjiayue主键
     * @return jingfeizhuanjiayue
     */
    public JingfeiZhuanjiaMonth selectJingfeiZhuanjiaMonthById(String id);


    public List<JingfeiZhuanjiaMonth> findByPiciIdAndLikeBeizhu1(@Param("piciid") String piciid,@Param("beizhu1") String beizhu1);
    /**
     * 查询jingfeizhuanjiayue列表
     * 
     * @param jingfeiZhuanjiaMonth jingfeizhuanjiayue
     * @return jingfeizhuanjiayue集合
     */
    public List<JingfeiZhuanjiaMonth> selectJingfeiZhuanjiaMonthList(JingfeiZhuanjiaMonth jingfeiZhuanjiaMonth);

    /**
     * 新增jingfeizhuanjiayue
     * 
     * @param jingfeiZhuanjiaMonth jingfeizhuanjiayue
     * @return 结果
     */
    public int insertJingfeiZhuanjiaMonth(JingfeiZhuanjiaMonth jingfeiZhuanjiaMonth);

    /**
     * 修改jingfeizhuanjiayue
     * 
     * @param jingfeiZhuanjiaMonth jingfeizhuanjiayue
     * @return 结果
     */
    public int updateJingfeiZhuanjiaMonth(JingfeiZhuanjiaMonth jingfeiZhuanjiaMonth);

    /**
     * 删除jingfeizhuanjiayue
     * 
     * @param id jingfeizhuanjiayue主键
     * @return 结果
     */
    public int deleteJingfeiZhuanjiaMonthById(String id);

    /**
     * 批量删除jingfeizhuanjiayue
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteJingfeiZhuanjiaMonthByIds(String[] ids);

    public int insertBatch(List<JingfeiZhuanjiaMonth> newJingfeiZhuanjiaMonthList);

    Long getPiciJingfeiSum(@Param("piciid") String piciid);
    Long getPiciJingfeiSumTiaojian(@Param("piciid") String piciid);
    Long getPiciBFJingfeiSum(@Param("piciid") String piciid);
    Long getPiciBFJingfeiSumTiaojian(@Param("piciid") String piciid);
    Object countzongrenshu(@Param("piciid") String piciid);
    Object countzongrenshuTiaojian(@Param("piciid") String piciid);
    Object countzlrenshu(@Param("piciid") String piciid);
    Object countzlrenshuTiaojian(@Param("piciid") String piciid);

    public int deleteByPiciId(@Param("piciid")String piciid);
    public int deleteJFDdptByPiciId(@Param("piciid")String piciid);
    public int deleteJFDdptMonthByPiciId(@Param("piciid")String piciid);
    public int deleteZJByPiciId(@Param("piciid")String piciid);

    public List<Map<String,Object>> findDeptJFByPiciId(@Param("piciid") String piciid);

    public List<Map<String,Object>> findDeptMonthJFByPiciId(@Param("piciid") String piciid);

    public List<Map<String,Object>> findZhuanjiaMonthJFByPiciId(@Param("piciid") String piciid);

    public List<Map<String,Object>> findZhuanjiaJFByPiciId(@Param("piciid") String piciid);

    public List<Map<String,Object>> findDeptJFMXByPiciId(@Param("piciid") String piciid);

    //有确认与延时条件
    public List<Map<String,Object>> findDeptJFMXByPiciIdTiaojian(@Param("piciid") String piciid);

    public List<JingfeiZhuanjiaMonth> findByPiciIdAndLikeBeizhu1AndNY(@Param("piciid") String piciid,@Param("beizhu1") String beizhu1,@Param("nianyue") String nianyue);
}
